Paul Newcome
Paul Newcome
-
Re: CountIF Month AND Year
Ah. Sorry for missing it on the first comment. The closing parenthesis after the 1 also needs to be removed.1 · -
Re: Bridge - Auto Delete Newly Added Columns
@Genevieve P. Exactly!! Just last week I used a similar method to get a variable list of columns from in between two other columns. Basically "give me all of the columns between the "Start&…1 · -
Re: Help with Index/Match + if blank
The initial "") is the output of the IFERROR. If there isn't a match with the INDEX/MATCH, the IFERROR outputs a blank. <> "" means "is not blank", so if there is …1 · -
Re: Whats wrong with this nested if and vlookup formula?
Happy to help. 👍️ A quick tip: If you catch yourself repeating the same pieces of a formula over and over again with the only difference being a single variable based on an IF, you can nest the IF in…2 · -
Re: Whats wrong with this nested if and vlookup formula?
You are closing out each IF statement before moving on to the next, but they need to be left open so that it is the "value if false" portion of the IF before. Notice the locations of the cl…1 ·
